# coding: utf-8
from common.models.user import User
from application import db


class CheckData(db.Model):
    __tablename__ = 'check_data'

    index = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    company = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    department = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    group = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))

    number = db.Column(db.Integer)

    days = db.Column(db.Float)
    vacation = db.Column(db.Float)
    annualvacation = db.Column(db.Float)
    absent = db.Column(db.Float)
    late = db.Column(db.Float)
    leave = db.Column(db.Float)
    sumvacation = db.Column(db.Float)
    overtime = db.Column(db.Float)

    month = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    years = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))

    num = db.Column(db.Integer)




